package com.woniuxy.main.dynamic_lzq.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.woniuxy.main.dynamic_lzq.pojo.Coach;
import com.woniuxy.main.dynamic_lzq.pojo.Course;

public interface CoachMapper_Lzq {
	
	@Select("select * from coach")
	List<Coach> showCoach();
	
	@Select("select * from coach where user_id = #{user_id}")
	Coach findCoachByUid(int user_id);
	
	@Select("select * from coach order by coach_price")
	List<Coach> listCoachesByPrice();
	
	@Select("select * from course where coach_id = #{coach_id}")
	List<Course> findCoursesByCid(int coach_id);
	
}
